SELECT
  O.OWNER
  , O.OBJECT_ID
  , O.OBJECT_NAME
  , O.OBJECT_TYPE
  , S.SID
  , S.SERIAL#
  , S.OSUSER
  , S.MACHINE
  , CASE
      WHEN S.STATUS IN ('ACTIVE', 'INACTIVE') THEN
        TO_CHAR(S.LAST_CALL_ET / 60, '999,999.9999')
      ELSE NULL
    END MINUTES_IN_WAIT
  , S.STATUS
  , SYSTIMESTAMP TIMEREC
FROM
  GV$LOCKED_OBJECT L
  , GV$SESSION S
  , DBA_OBJECTS O
WHERE
  L.ORACLE_USERNAME = 'RMS13PROD'
  AND S.SID = L.SESSION_ID
  AND O.OBJECT_ID = L.OBJECT_ID
  AND O.OBJECT_NAME = 'RPM_STAGE_ITEM_LOC'
--  AND O.OBJECT_TYPE = 'TABLE'
ORDER BY S.SID DESC
;